{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_BMa\Subsidies Project\Results\Comparison.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}18 Feb 2021, 15:03:00
{txt}
{com}. 
. use "R:\WSV2\TBu_BMa\Subsidies Project\Data Subsidies\Estimation Sample.dta" 
{txt}
{com}. 
. 
. tab loading_kg

 {txt}loading_kg {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
         10 {c |}{res}      6,636        0.86        0.86
{txt}       10.1 {c |}{res}        192        0.02        0.88
{txt}       10.5 {c |}{res}        232        0.03        0.91
{txt}         11 {c |}{res}      2,978        0.39        1.30
{txt}       11.5 {c |}{res}        108        0.01        1.31
{txt}         12 {c |}{res}      1,830        0.24        1.55
{txt}         13 {c |}{res}        188        0.02        1.57
{txt}         15 {c |}{res}         96        0.01        1.59
{txt}        2.5 {c |}{res}        120        0.02        1.60
{txt}          3 {c |}{res}      1,924        0.25        1.85
{txt}        3.5 {c |}{res}      6,617        0.86        2.71
{txt}        3.6 {c |}{res}         48        0.01        2.71
{txt}          4 {c |}{res}      6,519        0.84        3.56
{txt}        4.2 {c |}{res}         84        0.01        3.57
{txt}        4.5 {c |}{res}     24,048        3.11        6.68
{txt}          5 {c |}{res}    182,327       23.61       30.29
{txt}        5.2 {c |}{res}        936        0.12       30.41
{txt}        5.5 {c |}{res}     37,251        4.82       35.23
{txt}          6 {c |}{res}    215,043       27.84       63.08
{txt}        6.2 {c |}{res}      1,002        0.13       63.20
{txt}        6.5 {c |}{res}      4,080        0.53       63.73
{txt}        6.8 {c |}{res}         24        0.00       63.74
{txt}          7 {c |}{res}    162,864       21.09       84.82
{txt}        7.2 {c |}{res}         24        0.00       84.83
{txt}        7.5 {c |}{res}      2,748        0.36       85.18
{txt}          8 {c |}{res}     90,067       11.66       96.84
{txt}        8.5 {c |}{res}        288        0.04       96.88
{txt}          9 {c |}{res}     24,030        3.11       99.99
{txt}    unknown {c |}{res}         72        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    772,376      100.00
{txt}
{com}. replace loading_kg="" if loading_kg=="n.a."
{txt}(0 real changes made)

{com}. replace loading_kg="" if loading_kg=="unknown"
{txt}(72 real changes made)

{com}. destring loading_kg, replace
{txt}loading_kg: all characters numeric; {res}replaced {txt}as {res}double
{txt}(1741057 missing values generated)
{res}{txt}
{com}. 
. 
. 
. 
. 
. *Note: These identifiers equal one even in years in which a product is not sold in the respective country (AT, HU, HR), but enters the country later.
. 
. **Identifier for all refrigerators/freezers sold in Austria and elsewhere 
. **2009
. gen a9=0
{txt}
{com}. replace a9=1 if country=="Austria" & (category=="refrigerator"|category=="freezer") & year==2009
{txt}(30,576 real changes made)

{com}. by id, sort: egen suma9=sum(a9)
{txt}
{com}. gen aff9=0
{txt}
{com}. replace aff9=1 if suma9>0
{txt}(411,298 real changes made)

{com}. 
. **2010
. gen a10=0
{txt}
{com}. replace a10=1 if country=="Austria" & (category=="refrigerator"|category=="freezer") & year==2010
{txt}(29,400 real changes made)

{com}. by id, sort: egen suma10=sum(a10)
{txt}
{com}. gen aff10=0
{txt}
{com}. replace aff10=1 if suma10>0
{txt}(430,097 real changes made)

{com}. 
. **Identifier for all refrigerators/freezers sold in Hungary and elsewhere
. gen h=0
{txt}
{com}. replace h=1 if country=="Hungary" & (category=="refrigerator"|category=="freezer")& year==2016
{txt}(17,820 real changes made)

{com}. by id, sort: egen sumh=sum(h)
{txt}
{com}. gen hff=0
{txt}
{com}. replace hff=1 if sumh>0
{txt}(227,259 real changes made)

{com}. 
. **Identifier for all refrigerators/freezers sold in Croatia and elsewhere
. gen c=0
{txt}
{com}. replace c=1 if country=="Croatia" & (category=="refrigerator"|category=="freezer")& year==2015
{txt}(10,128 real changes made)

{com}. by id, sort: egen sumc=sum(c)
{txt}
{com}. gen cff=0
{txt}
{com}. replace cff=1 if sumc>0
{txt}(182,268 real changes made)

{com}. 
. **Identifier for all washing machines sold in Austria and elsewhere
. gen a1=0
{txt}
{com}. replace a1=1 if country=="Austria" & (category=="washing machine")&year==2010
{txt}(10,332 real changes made)

{com}. by id, sort: egen suma1=sum(a1)
{txt}
{com}. gen aw=0
{txt}
{com}. replace aw=1 if suma1>0
{txt}(119,028 real changes made)

{com}. 
. **Identifier for all washing machines sold in Hungary and elsewhere
. gen h1=0
{txt}
{com}. replace h1=1 if country=="Hungary" & (category=="washing machine")& year==2015
{txt}(10,044 real changes made)

{com}. by id, sort: egen sumh1=sum(h1)
{txt}
{com}. gen hw=0
{txt}
{com}. replace hw=1 if sumh1>0
{txt}(115,986 real changes made)

{com}. 
. **Identifier for all washing machines sold in Croatia and elsewhere
. gen c1=0
{txt}
{com}. replace c1=1 if country=="Croatia" & (category=="washing machine")& year==2015
{txt}(6,612 real changes made)

{com}. by id, sort: egen sumc1=sum(c1)
{txt}
{com}. gen cw=0
{txt}
{com}. replace cw=1 if sumc1>0
{txt}(86,661 real changes made)

{com}. 
. **Austria, 2009 REF/FRZ program
. preserve
{txt}
{com}. keep if country=="Austria"
{txt}(2,023,539 observations deleted)

{com}. keep if (category=="refrigerator"|category=="freezer")
{txt}(127,269 observations deleted)

{com}. 
. **kWh
. egen            median_all                      =median(annual_energy_consumption)                      if                              year==2009
{txt}(331977 missing values generated)

{com}. egen            median_treat            =median(annual_energy_consumption)                      if treataf==1 & year==2009
{txt}(357981 missing values generated)

{com}. gen             kwh_rel                         =median_treat/median_all                                    if treataf==1 & year==2009
{txt}(357,981 missing values generated)

{com}. sum             kwh_rel 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}kwh_rel {c |}{res}      4,572    .7973568           0   .7973568   .7973568
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      ((year==2008 & month>5)|(year==2009 & month<=5)) & aff9==1
{txt}(337822 missing values generated)

{com}. egen            median_treat_units      =median(units)                                                      if treataf==1 &     ((year==2008 & month>5)|(year==2009 & month<=5))
{txt}(359115 missing values generated)

{com}. gen             units_rel                       =median_treat_units/median_all_units        if treataf==1 &     ((year==2008 & month>5)|(year==2009 & month<=5)) & aff9==1
{txt}(359,318 missing values generated)

{com}. sum             units_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}units_rel {c |}{res}      3,235    .8798575           0   .8798575   .8798575
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             ((year==2008 & month>5)|(year==2009 & month<=5)) & aff9==1
{txt}(337822 missing values generated)

{com}. egen            median_treat_price      =median(price_eur)                                                       if treataf==1 &        ((year==2008 & month>5)|(year==2009 & month<=5))
{txt}(359115 missing values generated)

{com}. gen             price_rel                       =median_treat_price/median_all_price         if treataf==1 &    ((year==2008 & month>5)|(year==2009 & month<=5)) & aff9==1
{txt}(359,318 missing values generated)

{com}. sum             price_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_rel {c |}{res}      3,235     1.28693           0    1.28693    1.28693
{txt}
{com}. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                      year==2009 
{txt}(331977 missing values generated)

{com}. egen            median_treat_age        =median(mage)                                                            if treataf==1 & year==2009
{txt}(357981 missing values generated)

{com}. gen             age_rel                         =median_treat_age/median_all_age                         if treataf==1 & year==2009     
{txt}(357,981 missing values generated)

{com}. sum             age_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}age_rel {c |}{res}      4,572    .5909091           0   .5909091   .5909091
{txt}
{com}. 
. **Subsidized models fraction of market
. 
. egen            sum_all_units   =sum(units)                                                                      if                                     ((year==2008 & month>5)|(year==2009 & month<=5)) 
{txt}(334077 missing values generated)

{com}. egen            sum_treat_units =sum(units)                                                                              if treataf==1 &                ((year==2008 & month>5)|(year==2009 & month<=5))
{txt}(359115 missing values generated)

{com}. gen             fraction                =sum_treat_units/sum_all_units          
{txt}(359,115 missing values generated)

{com}. sum             fraction                                

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}fraction {c |}{res}      3,438    .0949436           0   .0949436   .0949436
{txt}
{com}. 
. restore
{txt}
{com}. 
. ***Austria, 2010 REF/FRZ program
. 
. preserve
{txt}
{com}. keep if country=="Austria"
{txt}(2,023,539 observations deleted)

{com}. keep if (category=="refrigerator"|category=="freezer")
{txt}(127,269 observations deleted)

{com}. 
. **kWh
. egen            median_all                      =median(annual_energy_consumption)                      if                              year==2010
{txt}(333153 missing values generated)

{com}. egen            median_treat            =median(annual_energy_consumption)                      if treataf==1 & year==2010
{txt}(356253 missing values generated)

{com}. gen             kwh_rel                         =median_treat/median_all                                    if treataf==1 & year==2010
{txt}(356,253 missing values generated)

{com}. sum             kwh_rel 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}kwh_rel {c |}{res}      6,300    .8495575           0   .8495575   .8495575
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      (year==2010 & month<=5) & aff10==1
{txt}(350303 missing values generated)

{com}. egen            median_treat_units      =median(units)                                                      if treataf==1 &     (year==2010 & month<=5)
{txt}(359928 missing values generated)

{com}. gen             units_rel                       =median_treat_units/median_all_units        if treataf==1 &     (year==2010 & month<=5) & aff10==1
{txt}(359,928 missing values generated)

{com}. sum             units_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}units_rel {c |}{res}      2,625    1.070659           0   1.070659   1.070659
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             (year==2010 & month<=5) & aff10==1
{txt}(350303 missing values generated)

{com}. egen            median_treat_price      =median(price_eur)                                                       if treataf==1 &        (year==2010 & month<=5)
{txt}(359928 missing values generated)

{com}. gen             price_rel                       =median_treat_price/median_all_price         if treataf==1 &    (year==2010 & month<=5) & aff10==1
{txt}(359,928 missing values generated)

{com}. sum             price_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_rel {c |}{res}      2,625    1.270627           0   1.270627   1.270627
{txt}
{com}. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                       year==2010 
{txt}(333153 missing values generated)

{com}. egen            median_treat_age        =median(mage)                                                            if treataf==1 & year==2010
{txt}(356253 missing values generated)

{com}. gen             age_rel                         =median_treat_age/median_all_age                         if treataf==1 & year==2010     
{txt}(356,253 missing values generated)

{com}. sum             age_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}age_rel {c |}{res}      6,300    .6956522           0   .6956522   .6956522
{txt}
{com}. 
. **Subsidized models fraction of market
. 
. egen            sum_all_units   =sum(units)                                                                      if                                     (year==2010 & month<=5)
{txt}(350303 missing values generated)

{com}. egen            sum_treat_units =sum(units)                                                                              if treataf==1 &                (year==2010 & month<=5)
{txt}(359928 missing values generated)

{com}. gen             fraction                =sum_treat_units/sum_all_units                          
{txt}(359,928 missing values generated)

{com}. sum             fraction

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}fraction {c |}{res}      2,625    .1992046           0   .1992046   .1992046
{txt}
{com}. 
. restore
{txt}
{com}. 
. ***Austria, 2010 WM program
. 
. preserve
{txt}
{com}. keep if country=="Austria"
{txt}(2,023,539 observations deleted)

{com}. keep if (category=="washing machine")
{txt}(362,553 observations deleted)

{com}. 
. gen             kwhkg=annual_energy_consumption/loading_kg
{txt}(53,021 missing values generated)

{com}. 
. **kWh
. egen            median_all                      =median(kwhkg)                                                          if                         year==2010
{txt}(116937 missing values generated)

{com}. egen            median_treat            =median(kwhkg)                                                          if treata==1 & year==2010
{txt}(125841 missing values generated)

{com}. gen             kwh_rel                         =median_treat/median_all                                    if treata==1 & year==2010
{txt}(125,841 missing values generated)

{com}. sum             kwh_rel 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}kwh_rel {c |}{res}      1,428    .8571429           0   .8571429   .8571429
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      (year==2009) & aw==1
{txt}(121065 missing values generated)

{com}. egen            median_treat_units      =median(units)                                                      if treata==1 &      (year==2009)
{txt}(126357 missing values generated)

{com}. gen             units_rel                       =median_treat_units/median_all_units        if treata==1 &          (year==2009) & aw==1
{txt}(126,453 missing values generated)

{com}. sum             units_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}units_rel {c |}{res}        816    .8209008           0   .8209008   .8209008
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             (year==2009) & aw==1
{txt}(121065 missing values generated)

{com}. egen            median_treat_price      =median(price_eur)                                                       if treata==1 &         (year==2009)
{txt}(126357 missing values generated)

{com}. gen             price_rel                       =median_treat_price/median_all_price         if treata==1 &     (year==2009) & aw==1
{txt}(126,453 missing values generated)

{com}. sum             price_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_rel {c |}{res}        816    1.553169           0   1.553169   1.553169
{txt}
{com}. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                     year==2010 
{txt}(116937 missing values generated)

{com}. egen            median_treat_age        =median(mage)                                                            if treata==1 & year==2010
{txt}(125841 missing values generated)

{com}. gen             age_rel                         =median_treat_age/median_all_age                         if treata==1 & year==2010      
{txt}(125,841 missing values generated)

{com}. sum             age_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}age_rel {c |}{res}      1,428    .8333333           0   .8333333   .8333333
{txt}
{com}. 
. egen            sum_all_units   =sum(units)                                                                      if                             (year==2009)
{txt}(116217 missing values generated)

{com}. egen            sum_treat_units =sum(units)                                                                              if treata==1 &         (year==2009)
{txt}(126357 missing values generated)

{com}. gen             fraction                =sum_treat_units/sum_all_units                          
{txt}(126,357 missing values generated)

{com}. sum             fraction

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}fraction {c |}{res}        912    .0693969           0   .0693969   .0693969
{txt}
{com}. 
. restore
{txt}
{com}. 
. 
. ***Hungary, 2016 REF/FRZ program
. 
. ***A+++
. preserve
{txt}
{com}. keep if country=="Hungary"
{txt}(2,200,397 observations deleted)

{com}. keep if (category=="refrigerator"|category=="freezer")
{txt}(111,134 observations deleted)

{com}. 
. **kWh
. egen            median_all                      =median(annual_energy_consumption)                      if                              year==2016
{txt}(184010 missing values generated)

{com}. egen            median_treat_3          =median(annual_energy_consumption)                      if treathf==1 & year==2016 & energy_label_eu=="A+++"
{txt}(200714 missing values generated)

{com}. gen             kwh_rel_3                       =median_treat_3/median_all                                  if treathf==1 & year==2016 & energy_label_eu=="A+++"
{txt}(200,714 missing values generated)

{com}. sum             kwh_rel_3 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_3 {c |}{res}      1,116    .6984816           0   .6984816   .6984816
{txt}
{com}. 
. egen            median_treat_2          =median(annual_energy_consumption)                      if treathf==1 & year==2016 & energy_label_eu=="A++"
{txt}(197426 missing values generated)

{com}. gen             kwh_rel_2                       =median_treat_2/median_all                                  if treathf==1 & year==2016 & energy_label_eu=="A++"
{txt}(197,426 missing values generated)

{com}. sum             kwh_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_2 {c |}{res}      4,404    1.006508           0   1.006508   1.006508
{txt}
{com}. 
. egen            median_treat_1          =median(annual_energy_consumption)                      if treathf==1 & year==2016 & energy_label_eu=="A+"
{txt}(197618 missing values generated)

{com}. gen             kwh_rel_1                       =median_treat_1/median_all                                  if treathf==1 & year==2016 & energy_label_eu=="A+"
{txt}(197,618 missing values generated)

{com}. sum             kwh_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_1 {c |}{res}      4,212    1.136659           0   1.136659   1.136659
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1
{txt}(187475 missing values generated)

{com}. egen            median_treat_units_3=median(units)                                                          if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+++"
{txt}(201015 missing values generated)

{com}. gen             units_rel_3                     =median_treat_units_3/median_all_units      if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1 & energy_label_eu=="A+++"
{txt}(201,036 missing values generated)

{com}. sum             units_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_3 {c |}{res}        794       .4475           0      .4475      .4475
{txt}
{com}. 
. egen            median_treat_units_2=median(units)                                                          if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A++"
{txt}(198343 missing values generated)

{com}. gen             units_rel_2                     =median_treat_units_2/median_all_units      if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1 & energy_label_eu=="A++"
{txt}(198,427 missing values generated)

{com}. sum             units_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_2 {c |}{res}      3,403          .9           0         .9         .9
{txt}
{com}. 
. egen            median_treat_units_1=median(units)                                                          if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+"
{txt}(198178 missing values generated)

{com}. gen             units_rel_1                     =median_treat_units_1/median_all_units      if treathf==1 &     ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1& energy_label_eu=="A+"
{txt}(198,241 missing values generated)

{com}. sum             units_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_1 {c |}{res}      3,589         2.2           0        2.2        2.2
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1
{txt}(187475 missing values generated)

{com}. egen            median_treat_price_3=median(price_eur)                                                   if treathf==1 &        ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+++"
{txt}(201015 missing values generated)

{com}. gen             price_rel_3                     =median_treat_price_3/median_all_price       if treathf==1 &    ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1 & energy_label_eu=="A+++"
{txt}(201,036 missing values generated)

{com}. sum             price_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_3 {c |}{res}        794    1.847711           0   1.847711   1.847711
{txt}
{com}. 
. egen            median_treat_price_2=median(price_eur)                                                   if treathf==1 &        ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A++"
{txt}(198343 missing values generated)

{com}. gen             price_rel_2                     =median_treat_price_2/median_all_price       if treathf==1 &    ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1 & energy_label_eu=="A++"
{txt}(198,427 missing values generated)

{com}. sum             price_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_2 {c |}{res}      3,403    1.279731           0   1.279731   1.279731
{txt}
{com}. 
. egen            median_treat_price_1    =median(price_eur)                                               if treathf==1 &        ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+"
{txt}(198178 missing values generated)

{com}. gen             price_rel_1                     =median_treat_price_1/median_all_price       if treathf==1 &    ((year==2015 & month>5)|(year==2016 & month<=5)) & hff==1 & energy_label_eu=="A+"
{txt}(198,241 missing values generated)

{com}. sum             price_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_1 {c |}{res}      3,589    .8216516           0   .8216516   .8216516
{txt}
{com}. 
. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                      year==2016 
{txt}(184010 missing values generated)

{com}. egen            median_treat_age_3      =median(mage)                                                            if treathf==1 & year==2016  & energy_label_eu=="A+++"
{txt}(200714 missing values generated)

{com}. gen             age_rel_3                       =median_treat_age_3/median_all_age                       if treathf==1 & year==2016      & energy_label_eu=="A+++"
{txt}(200,714 missing values generated)

{com}. sum             age_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_3 {c |}{res}      1,116    .5769231           0   .5769231   .5769231
{txt}
{com}. 
. egen            median_treat_age_2      =median(mage)                                                            if treathf==1 & year==2016  & energy_label_eu=="A++"
{txt}(197426 missing values generated)

{com}. gen             age_rel_2                       =median_treat_age_2/median_all_age                       if treathf==1 & year==2016      & energy_label_eu=="A++"
{txt}(197,426 missing values generated)

{com}. sum             age_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_2 {c |}{res}      4,404    .8076923           0   .8076923   .8076923
{txt}
{com}.  
. egen            median_treat_age_1      =median(mage)                                                            if treathf==1 & year==2016  & energy_label_eu=="A+"
{txt}(197618 missing values generated)

{com}. gen             age_rel_1                       =median_treat_age_1/median_all_age                       if treathf==1 & year==2016      & energy_label_eu=="A+"
{txt}(197,618 missing values generated)

{com}. sum             age_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_1 {c |}{res}      4,212    1.230769           0   1.230769   1.230769
{txt}
{com}. 
. **Fraction treated from total market
. egen            sum_all_units   =sum(units)                                                                      if                                     ((year==2015 & month>5)|(year==2016 & month<=5))
{txt}(184311 missing values generated)

{com}. egen            sum_treat_units_3=sum(units)                                                                     if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+++"
{txt}(201015 missing values generated)

{com}. gen             fraction_3              =sum_treat_units_3/sum_all_units                                 if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+++"
{txt}(201,015 missing values generated)

{com}. 
. egen            sum_treat_units_2=sum(units)                                                                     if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A++"
{txt}(198343 missing values generated)

{com}. gen             fraction_2              =sum_treat_units_2/sum_all_units                                 if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A++"
{txt}(198,343 missing values generated)

{com}. 
. egen            sum_treat_units_1=sum(units)                                                                     if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+"
{txt}(198178 missing values generated)

{com}. gen             fraction_1              =sum_treat_units_1/sum_all_units                                 if treathf==1 &                ((year==2015 & month>5)|(year==2016 & month<=5)) & energy_label_eu=="A+"
{txt}(198,178 missing values generated)

{com}.         
. sum             fraction_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_3 {c |}{res}        815    .0103271           0   .0103271   .0103271
{txt}
{com}. sum             fraction_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_2 {c |}{res}      3,487    .1772191           0   .1772191   .1772191
{txt}
{com}. sum             fraction_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_1 {c |}{res}      3,652    .6859692           0   .6859692   .6859692
{txt}
{com}. 
. restore
{txt}
{com}. 
. 
. ***Hungary, 2015 WM program
. 
. ***A+++
. preserve
{txt}
{com}. keep if country=="Hungary"
{txt}(2,200,397 observations deleted)

{com}. keep if (category=="washing machine")
{txt}(201,830 observations deleted)

{com}. gen             kwhkg=annual_energy_consumption/loading_kg
{txt}(54,207 missing values generated)

{com}. 
. **kWh
. egen            median_all                      =median(kwhkg)                                                          if                              year==2015
{txt}(101090 missing values generated)

{com}. egen            median_treat_3          =median(kwhkg)                                                          if treath==1 & year==2015 & energy_label_eu=="A+++"
{txt}(108434 missing values generated)

{com}. gen             kwh_rel_3                       =median_treat_3/median_all                                  if treath==1 & year==2015 & energy_label_eu=="A+++"
{txt}(108,434 missing values generated)

{com}. sum             kwh_rel_3 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_3 {c |}{res}      2,700    .9117897           0   .9117897   .9117897
{txt}
{com}. 
. egen            median_treat_2          =median(kwhkg)                                                          if treath==1 & year==2015 & energy_label_eu=="A++"
{txt}(110234 missing values generated)

{com}. gen             kwh_rel_2                       =median_treat_2/median_all                                  if treath==1 & year==2015 & energy_label_eu=="A++"
{txt}(110,234 missing values generated)

{com}. sum             kwh_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_2 {c |}{res}        900    1.081425           0   1.081425   1.081425
{txt}
{com}. 
. egen            median_treat_1          =median(kwhkg)                                                          if treath==1 & year==2015 & energy_label_eu=="A+"
{txt}(110690 missing values generated)

{com}. gen             kwh_rel_1                       =median_treat_1/median_all                                  if treath==1 & year==2015 & energy_label_eu=="A+"
{txt}(110,690 missing values generated)

{com}. sum             kwh_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}kwh_rel_1 {c |}{res}        444    1.259542           0   1.259542   1.259542
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1
{txt}(102710 missing values generated)

{com}. egen            median_treat_units_3=median(units)                                                          if treath==1 &      ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+++"
{txt}(108884 missing values generated)

{com}. gen             units_rel_3                     =median_treat_units_3/median_all_units      if treath==1 &          ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1 & energy_label_eu=="A+++"
{txt}(108,932 missing values generated)

{com}. sum             units_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_3 {c |}{res}      2,202    1.333333           0   1.333333   1.333333
{txt}
{com}. 
. egen            median_treat_units_2=median(units)                                                          if treath==1 &      ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A++"
{txt}(110348 missing values generated)

{com}. gen             units_rel_2                     =median_treat_units_2/median_all_units      if treath==1 &          ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1 & energy_label_eu=="A++"
{txt}(110,372 missing values generated)

{com}. sum             units_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_2 {c |}{res}        762     3.94375           0    3.94375    3.94375
{txt}
{com}. 
. egen            median_treat_units_1=median(units)                                                          if treath==1 &      ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+"
{txt}(110696 missing values generated)

{com}. gen             units_rel_1                     =median_treat_units_1/median_all_units      if treath==1 &          ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1& energy_label_eu=="A+"
{txt}(110,744 missing values generated)

{com}. sum             units_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}units_rel_1 {c |}{res}        390         7.5           0        7.5        7.5
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1
{txt}(102710 missing values generated)

{com}. egen            median_treat_price_3=median(price_eur)                                                   if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+++"
{txt}(108884 missing values generated)

{com}. gen             price_rel_3                     =median_treat_price_3/median_all_price       if treath==1 &     ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1 & energy_label_eu=="A+++"
{txt}(108,932 missing values generated)

{com}. sum             price_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_3 {c |}{res}      2,202    1.119649           0   1.119649   1.119649
{txt}
{com}. 
. egen            median_treat_price_2=median(price_eur)                                                   if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A++"
{txt}(110348 missing values generated)

{com}. gen             price_rel_2                     =median_treat_price_2/median_all_price       if treath==1 &     ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1 & energy_label_eu=="A++"
{txt}(110,372 missing values generated)

{com}. sum             price_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_2 {c |}{res}        762     .845876           0    .845876    .845876
{txt}
{com}. 
. egen            median_treat_price_1    =median(price_eur)                                               if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+"
{txt}(110696 missing values generated)

{com}. gen             price_rel_1                     =median_treat_price_1/median_all_price       if treath==1 &     ((year==2014 & month>6)|(year==2015 & month<=6)) & hw==1 & energy_label_eu=="A+"
{txt}(110,744 missing values generated)

{com}. sum             price_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 1}price_rel_1 {c |}{res}        390     .704572           0    .704572    .704572
{txt}
{com}. 
. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                      year==2015 
{txt}(101090 missing values generated)

{com}. egen            median_treat_age_3      =median(mage)                                                            if treath==1 & year==2015  & energy_label_eu=="A+++"
{txt}(108434 missing values generated)

{com}. gen             age_rel_3                       =median_treat_age_3/median_all_age                       if treath==1 & year==2015      & energy_label_eu=="A+++"
{txt}(108,434 missing values generated)

{com}. sum             age_rel_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_3 {c |}{res}      2,700    .8095238           0   .8095238   .8095238
{txt}
{com}. 
. egen            median_treat_age_2      =median(mage)                                                            if treath==1 & year==2015  & energy_label_eu=="A++"
{txt}(110234 missing values generated)

{com}. gen             age_rel_2                       =median_treat_age_2/median_all_age                       if treath==1 & year==2015      & energy_label_eu=="A++"
{txt}(110,234 missing values generated)

{com}. sum             age_rel_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_2 {c |}{res}        900     .952381           0    .952381    .952381
{txt}
{com}.  
. egen            median_treat_age_1      =median(mage)                                                            if treath==1 & year==2015  & energy_label_eu=="A+"
{txt}(110690 missing values generated)

{com}. gen             age_rel_1                       =median_treat_age_1/median_all_age                       if treath==1 & year==2015      & energy_label_eu=="A+"
{txt}(110,690 missing values generated)

{com}. sum             age_rel_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}age_rel_1 {c |}{res}        444    1.261905           0   1.261905   1.261905
{txt}
{com}. 
. **Fraction treated from total market
. 
. egen            sum_all_units   =sum(units)                                                                      if                             ((year==2014 & month>6)|(year==2015 & month<=6))
{txt}(100382 missing values generated)

{com}. egen            sum_treat_units_3=sum(units)                                                                     if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+++"
{txt}(108884 missing values generated)

{com}. gen             fraction_3              =sum_treat_units_3/sum_all_units                                 if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+++"
{txt}(108,884 missing values generated)

{com}. 
. egen            sum_treat_units_2=sum(units)                                                                     if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A++"
{txt}(110348 missing values generated)

{com}. gen             fraction_2              =sum_treat_units_2/sum_all_units                                 if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A++"
{txt}(110,348 missing values generated)

{com}. 
. egen            sum_treat_units_1=sum(units)                                                                     if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+"
{txt}(110696 missing values generated)

{com}. gen             fraction_1              =sum_treat_units_1/sum_all_units                                 if treath==1 &         ((year==2014 & month>6)|(year==2015 & month<=6)) & energy_label_eu=="A+"
{txt}(110,696 missing values generated)

{com}.         
. sum             fraction_3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_3 {c |}{res}      2,250    .2328269           0   .2328269   .2328269
{txt}
{com}. sum             fraction_2

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_2 {c |}{res}        786    .2480964           0   .2480964   .2480964
{txt}
{com}. sum             fraction_1

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}fraction_1 {c |}{res}        438    .3057601           0   .3057601   .3057601
{txt}
{com}.         
. restore
{txt}
{com}. 
. 
. ***Croatia, 2015 REF/FRZ 
. 
. preserve
{txt}
{com}. keep if country=="Croatia"
{txt}(2,331,153 observations deleted)

{com}. keep if (category=="refrigerator"|category=="freezer")
{txt}(68,056 observations deleted)

{com}. 
. **kWh
. egen            median_all                      =median(annual_energy_consumption)                      if                         year==2015
{txt}(104024 missing values generated)

{com}. egen            median_treat            =median(annual_energy_consumption)                      if treatc==1 & year==2015
{txt}(113756 missing values generated)

{com}. gen             kwh_rel                         =median_treat/median_all                                    if treatc==1 & year==2015
{txt}(113,756 missing values generated)

{com}. sum             kwh_rel 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}kwh_rel {c |}{res}        396    .6514523           0   .6514523   .6514523
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      ((year==2014 & month>2)|(year==2015 & month<=2)) & cff==1
{txt}(106324 missing values generated)

{com}. egen            median_treat_units      =median(units)                                                      if treatc==1 &      ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(113906 missing values generated)

{com}. gen             units_rel                       =median_treat_units/median_all_units        if treatc==1 &      ((year==2014 & month>2)|(year==2015 & month<=2)) & cff==1
{txt}(113,946 missing values generated)

{com}. sum             units_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}units_rel {c |}{res}        206    .4784033           0   .4784033   .4784033
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             ((year==2014 & month>2)|(year==2015 & month<=2)) & cff==1
{txt}(106324 missing values generated)

{com}. egen            median_treat_price      =median(price_eur)                                                       if treatc==1 &         ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(113906 missing values generated)

{com}. gen             price_rel                       =median_treat_price/median_all_price         if treatc==1 &     ((year==2014 & month>2)|(year==2015 & month<=2)) & cff==1
{txt}(113,946 missing values generated)

{com}. sum             price_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_rel {c |}{res}        206      1.9851           0     1.9851     1.9851
{txt}
{com}. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                     year==2015
{txt}(104024 missing values generated)

{com}. egen            median_treat_age        =median(mage)                                                            if treatc==1 & year==2015
{txt}(113756 missing values generated)

{com}. gen             age_rel                         =median_treat_age/median_all_age                         if treatc==1 & year==2015      
{txt}(113,756 missing values generated)

{com}. sum             age_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}age_rel {c |}{res}        396    .4444444           0   .4444444   .4444444
{txt}
{com}. 
. egen            sum_all_units   =sum(units)                                                                      if                             ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(103194 missing values generated)

{com}. egen            sum_treat_units=sum(units)                                                                               if treatc==1 & ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(113906 missing values generated)

{com}. gen             fraction                =sum_treat_units/sum_all_units                          
{txt}(113,906 missing values generated)

{com}. 
. sum             fraction

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}fraction {c |}{res}        246    .0054821           0   .0054821   .0054821
{txt}
{com}. 
. 
. restore
{txt}
{com}. 
. ***Croatia, 2015 WM 
. 
. preserve
{txt}
{com}. keep if country=="Croatia"
{txt}(2,331,153 observations deleted)

{com}. keep if (category=="washing machine")
{txt}(114,152 observations deleted)

{com}. gen             kwhkg=annual_energy_consumption/loading_kg
{txt}(32,561 missing values generated)

{com}. 
. 
. **kWh
. egen            median_all                      =median(kwhkg)                                                          if                         year==2015
{txt}(61444 missing values generated)

{com}. egen            median_treat            =median(kwhkg)                                                          if treatc==1 & year==2015
{txt}(64840 missing values generated)

{com}. gen             kwh_rel                         =median_treat/median_all                                    if treatc==1 & year==2015
{txt}(64,840 missing values generated)

{com}. sum             kwh_rel 

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}kwh_rel {c |}{res}      3,216    .9411765           0   .9411765   .9411765
{txt}
{com}. 
. **Units
. egen            median_all_units        =median(units)                                                          if                                      ((year==2014 & month>2)|(year==2015 & month<=2)) & cw==1
{txt}(63224 missing values generated)

{com}. egen            median_treat_units      =median(units)                                                      if treatc==1 &      ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(65590 missing values generated)

{com}. gen             units_rel                       =median_treat_units/median_all_units        if treatc==1 &      ((year==2014 & month>2)|(year==2015 & month<=2)) & cw==1
{txt}(65,970 missing values generated)

{com}. sum             units_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}units_rel {c |}{res}      2,086    .8965946           0   .8965946   .8965946
{txt}
{com}. 
. **Price
. egen            median_all_price        =median(price_eur)                                                       if                             ((year==2014 & month>2)|(year==2015 & month<=2)) & cw==1
{txt}(63224 missing values generated)

{com}. egen            median_treat_price      =median(price_eur)                                                       if treatc==1 &         ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(65590 missing values generated)

{com}. gen             price_rel                       =median_treat_price/median_all_price         if treatc==1 &     ((year==2014 & month>2)|(year==2015 & month<=2)) & cw==1
{txt}(65,970 missing values generated)

{com}. sum             price_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_rel {c |}{res}      2,086    1.111696           0   1.111696   1.111696
{txt}
{com}. 
. **Age
. egen            median_all_age      =median(mage)                                                                if                     year==2015
{txt}(61444 missing values generated)

{com}. egen            median_treat_age        =median(mage)                                                            if treatc==1 & year==2015
{txt}(64840 missing values generated)

{com}. gen             age_rel                         =median_treat_age/median_all_age                         if treatc==1 & year==2015      
{txt}(64,840 missing values generated)

{com}. sum             age_rel

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}age_rel {c |}{res}      3,216    .7391304           0   .7391304   .7391304
{txt}
{com}. 
. egen            sum_all_units   =sum(units)                                                                      if                             ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(61084 missing values generated)

{com}. egen            sum_treat_units=sum(units)                                                                               if treatc==1 & ((year==2014 & month>2)|(year==2015 & month<=2))
{txt}(65590 missing values generated)

{com}. gen             fraction                =sum_treat_units/sum_all_units                          
{txt}(65,590 missing values generated)

{com}. sum             fraction

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}fraction {c |}{res}      2,466    .3493528           0   .3493528   .3493528
{txt}
{com}. 
. restore
{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_BMa\Subsidies Project\Results\Comparison.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}18 Feb 2021, 15:08:13
{txt}{.-}
{smcl}
{txt}{sf}{ul off}